Viewing 15 posts - 286 through 300 (of 699 total)
Ah okay - so you're not using UNC path format.
Okay, this should work then:
REVERSE(SUBSTRING(REVERSE([Variable]), 1, FINDSTRING("\", REVERSE([Variable]), 1)))
September 26, 2011 at 1:36 pm
Paste an example of your file names and I'll see what I can do
September 26, 2011 at 12:01 pm
Are you asking for a method to have SSIS create a stored procedure for you, and then run it?
Because from your original question, its not clear to me why you...
September 26, 2011 at 8:49 am
What you can do is have an event trigger in outlook which, upon receiving an email, will execute a batch file that will in turn execute a DTEXEC command line...
September 26, 2011 at 8:28 am
Another possible approach would be to do this in two steps. First, import all your records into the table exactly as you have them in the files - so you'll...
September 22, 2011 at 11:01 am
What? seriously? Okay ... learned something new then. thanks!
September 22, 2011 at 10:24 am
You should usually start a new thread, instead of continuing a two year old one 😛
Try throwing in a data conversion step, and convert your column through that. Near the...
September 22, 2011 at 9:11 am
No you can't. Flat File doesn't support the tilda character ("~") as a delimiter.
You have two solutions. You can use the raw file import, and thus have no text delimiter....
September 22, 2011 at 9:08 am
A bit of an uglier fix maybe, but I've found for ADO.NET connections, you pretty much need to use the DataReader source instead of the OLE DB source.
September 22, 2011 at 9:03 am
From personal experience, I find the best way to "learn" something is trial by fire. Start messing around with the new software directly with the project that you plan on...
September 21, 2011 at 10:19 am
Yea I was thinking alternatively just looking for the line "KIN 06/03/08 ( PAID CHECK # 791 )", since that seems also like a fixed point. Doing a raw file...
September 21, 2011 at 8:04 am
There probably is a way, using some form of Execute SQL Task, but that's beyond my scope of knowledge, sorry :/
September 15, 2011 at 11:26 am
Not enough details on the problem to really be able to answer it, but it seems to me like if you had a table that stored all your servers, and...
September 15, 2011 at 10:43 am
You could probably forego the script task by having two outputs from the Execute SQL Task, and assigning the paths to an Expression evaluation.
September 15, 2011 at 8:43 am
SSIS is not designed for updating. It's designed for taking data and transforming it, then putting the results in a destination.
If you really want to be doing the updates through...
September 15, 2011 at 8:42 am
Viewing 15 posts - 286 through 300 (of 699 total)