|
|
Browse by Tags
All Tags » SQL Server » Dataflow Task » SSIS
-
Someone emailed me today asking:
I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file]
What is the easiest way to then after processing has completed:
A) Check to see whether there has been any data that could not be ...
-
An interesting problem has been posed on the SSIS forum at SQL Server Central. The user wants to download a file containing stock information from Yahoo finance and import the data into a database table.
That sounded like an interesting problem so I took up the challenge. The basis of my solution uses the code that Ashvini ...
-
It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here.
Basically, its not possible to do this without using a workaround. There are two possible workarounds ...
|
|
|