CptCrusty1 (4/23/2013)

---

Yes, I'm kind of a noob with SSIS. We frequently move hundreds of thousands of records from Text files to Raw tables, and ultimatley to production. After...

Have you checked out the Conditional Split transformation? It allows you to redirect data based on tests such as these, so you could split your input into multiple streams, with...

Execute At [linked_server]

causes the statement to be executed on the linked server (not on the server running the EXECUTE statement). Is that what you mean?

--Edit:...

Your message is a little confusing: are you importing or (I think) exporting?

What do you mean when you say that your file layout "becomes a mess"? Can you provide some...

Taking SSIS out of the equation for a moment, do the queries run quickly in SSMS?

You need to do some detective work to understand exactly where the bottleneck is.

If E: is not a local drive on the server, I would try using a UNC file path instead.

Great - thanks for that!

Have you configured the output as 'Append' or 'Overwrite'?

If only the final file is appearing in there, I would suspect 'Overwrite'.

Andrew Watson-478275 (4/19/2013)

---

Yes, but it will recalculate that connectionstring every time it uses it (i.e. every time round the loop).

Create a new variable User::FullOutputFileName (or whatever), and assign its value...

No. Each side of the AND condition has to be evaluated to determine whether the row is selected.

But...

SQL Knight (4/18/2013)

---

All 3 of these AS Clause below will work in MS T-SQL.

But my question is which on is more proper type of formatting for T-SQL (Now and in...

I've just read this a few times and I'm still not sure what you mean. What, exactly, do you mean by 'short circuit'?

manibad (4/18/2013)

---

thanks for everyone who have replied..

Actually i am not in a position to work on SQl or Script task and code the data to achieve my destiny..i can do...

I don't think that there is an IsDate function in SSIS. If you don't mind doing a bit of coding, you could create a script component and do a Regex...

You are responding to a post which is nearly five years old.