Viewing 15 posts - 4,906 through 4,920 (of 11,678 total)
SSIS can't handle files like these. You'll need a script component to parse it.
September 10, 2013 at 12:50 am
A function has a fixed output in the sense that the metadata of the columns returned is known upfront. Functions are thus meant to return data.
Stored procedures however can do...
September 10, 2013 at 12:49 am
AndrewSQLDBA (9/9/2013)
September 10, 2013 at 12:47 am
bob_balok (9/9/2013)
September 9, 2013 at 1:54 pm
You need to open the file and take a look yourself.
Typically the analysis (if there is any) of your import should contain these details.
September 9, 2013 at 12:27 pm
You could also do it with some .net coding in an asynchronous script component.
You read the value from number and use it in a for loop.
In each iteration of the...
September 9, 2013 at 3:51 am
Wouldn't it be faster to transfer everything to SQL Server and then delete everything you don't need?
September 9, 2013 at 3:20 am
Personally, I'd go for the 2012 certificates.
They are a bit harder to get than the 2008 exams (you now have to do three exams), but you get to know the...
September 6, 2013 at 7:32 am
TheSQLGuru (9/6/2013)
September 6, 2013 at 6:45 am
Mr. Kapsicum (9/6/2013)
Koen Verbeeck (9/6/2013)
What problems are you running into?
Thanks for acknowledging my problem.
In a nutshell, i want a Script for my script task that delete all files...
September 6, 2013 at 6:43 am
What problems are you running into?
September 6, 2013 at 5:02 am
You can create a string variable in SSIS containing your SQL statement. Just add the IDs you extracted to this variable using an expression.
In the OLE DB Source, use the...
September 6, 2013 at 5:02 am
MarkusB (9/6/2013)
Create your package with two "file system tasks" connect them with an "on success" connection.
Then define a variable "sourcepath" and change the sourceconnection...
September 6, 2013 at 3:59 am
Viewing 15 posts - 4,906 through 4,920 (of 11,678 total)