June 10, 2008 at 2:16 am
Hi,
This might be a silly question, but here we go:
I want to test my SSIS package without actually executing it. The reason for this is that the package reads from a flat file, updates or inserts into a table in a database, depending on whether or not the data is there, then archives the file once done.
I mainly want to see if the flat file to table mappings are correct - without actually executing the package - thereby updating / inserting into the table.
Is something like this possible?
June 10, 2008 at 5:10 am
You could very carefully configure the transactions in the package to error and roll everything back, but it is risky. The best solution would be for you to create a test database.
June 10, 2008 at 8:14 am
Deplicate your table which is used to insert data from the flat file and then execute your package to import data into your duplicated table. So you can check and see if your process is correct.
--------------------------------------------------------------
DBA or SQL Programmer? Who Knows. :unsure:
June 10, 2008 at 8:17 am
I would go for creating a test database (as Michael suggests), or a test environment, which would allow me to do everything as required, and to configure everything with SSIS configs, which I could change per environment.
That way, when it hits production, its pretty tested and secure to do against the main objects, and I am not changing anything in SSIS design
~PD
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply