Viewing 15 posts - 9,571 through 9,585 (of 11,678 total)
Good that you find the solution and thanks for posting it here.
I'd just want to add that one should always use the SQL command instead of the "table or view"...
April 18, 2011 at 12:10 am
Wouldn't the "easiest" solution be to just write a script task in .NET and read out that one single line?
Or am I missing something here?
April 18, 2011 at 12:06 am
The answer has been given in the following thread:
http://www.sqlservercentral.com/Forums/Topic1094054-148-1.aspx
April 18, 2011 at 12:04 am
The problem is that you are using numbers in your expression, but as result you give in some branches the empty string.
Strings and numbers aren't compatible, so either use NULL...
April 17, 2011 at 11:59 pm
What are you using as a business key to uniquely identify a record?
April 17, 2011 at 11:55 pm
To add a new dimension, you first populate the new dimension (obviously :-)) in the datawarehouse.
Then you add a new surrogate key field in the fact table and you change...
April 17, 2011 at 11:53 pm
SKYBVI (4/15/2011)
Horrible!!!This is sql server forum for people all over the world...
How can u ask questions related to US....????
Wat abt the people outside states??
If you've read the editorial, the question...
April 15, 2011 at 7:20 am
chetanb3 (4/15/2011)
I have another question, If I add the log provider as text file for master package..will that be ok.. I mean the file will contain log from child packages.....
April 15, 2011 at 2:35 am
Phil Parkin (4/15/2011)
That's also the only idea I had for this one.
That's because great minds think alike 😀
(Right now, I'm thinking of a combination of Friday and beer. You?)
April 15, 2011 at 2:30 am
A possible solution:
read the directory contents with a script task and store all the filenames in a table in the order that you want.
Then loop over the table with a...
April 15, 2011 at 2:27 am
What destination component did you use exactly?
Is it a problem that the table is locked?
April 15, 2011 at 2:24 am
You could use a script component to do this in your dataflow. Keep some variables in the script that check the conditions and update the sequence accordingly.
April 15, 2011 at 2:22 am
You can search the XML file for the variable.
(the .dtsx file is actually just XML)
On a sidenote:
it is a best practice to keep your packages small and modular. Just to...
April 15, 2011 at 2:19 am
Maybe this thread can help you:
April 15, 2011 at 2:18 am
Viewing 15 posts - 9,571 through 9,585 (of 11,678 total)