Saturday, May 18, 2013

[MS SQL Server] Problem in SSIS

[MS SQL Server] Problem in SSIS

Problem in SSIS

Posted: 17 May 2013 10:40 PM PDT

dear alli have a issue there are millions of records in source file and if it fails at 1000th record how will solve itRegards

Scalar-valued Function Security Access

Posted: 17 May 2013 09:19 AM PDT

There is a scalar-valued function on prodcution that is not replicated to our report server (which I need it to be). In the meantime, the DBA simply scripted the function (from prod) and ran it on the replica server. She can see it, but no one else could. I can see it on a couple of our other DB's where the db_executor security is set (because I'm a member of that group or higher on those DB's). Doesn't the DBA have to add the security of public or something that would grant access for the report tool and users to access function?(let's not get into why this function is used in reporting... that's a whole nother ball of wax, case of beer, and thread!)

export to flat file is failed

Posted: 23 Feb 2013 06:03 PM PST

Dear ExpertsI am trying to export data from table to a flat file but this error recured on several fieldsError 0xc00470d4: Data Flow Task 1: The code page on input column "patient_id" (439) is 1252 and is required to be 1256. (SQL Server Import and Export Wizard)any idea how to solve this problem, thanks

Removing non-indexed Partitions

Posted: 17 May 2013 05:33 AM PDT

I have a partition file for a table that does not have an index. Unfortunately, I have reused the Partition Function to create several other partitioned tables with the same index field. Lesson learned...I need to be able to switch out the partitions to a table or somehow truncate the data that is in the partitioned heap without removing the other indexed and partitioned data. I have read a ton about this subject online but have not found a solution that will remedy this situation.Situation:I have Table1 with a YearMonth field and there are 2 different Partition files (1 with Clustered Index and 1 without an index) and the Primary associated to the table. When I look up the list of partition numbers, they are repeated (1-97) for both files, so I am afraid that if I try to switch out Partition # 1 that it will grab data from both files.Any ideas on how I can fix this mess?Thanks, Scott
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog