September 26, 2011 at 11:03 am
How to make it work so whenever you start SSIS that it imports a different file? A part of the file would be put in manually or it would take the current date. So the file would look like import26092011.txt, for the next day it would be import27092011.txt
im a newbie at this and the only thing that i have found in data flow is to have a "fixed" name.
So, if anyone would help me out, step by step if possible or direct me where i could find more info. Tried looking in here but couldnt really find anything helpful
Oh, yeah-this is for SQL Server 2008
September 26, 2011 at 11:10 am
In the properties for the file connection, build the Connection string to be dynamic using the Expressions option.
You can build the connection string using variables based on the current date, or other options.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 26, 2011 at 11:12 am
vprunic (9/26/2011)
How to make it work so whenever you start SSIS that it imports a different file? A part of the file would be put in manually or it would take the current date. So the file would look like import26092011.txt, for the next day it would be import27092011.txtim a newbie at this and the only thing that i have found in data flow is to have a "fixed" name.
So, if anyone would help me out, step by step if possible or direct me where i could find more info. Tried looking in here but couldnt really find anything helpful
Oh, yeah-this is for SQL Server 2008
if you're still having difficulties here is the step-by-step which GSquared mentioned.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply