Hi Andrew,
I have a problem in using SQL table for package configuration.Let me explain in detail.
I have the task Flatfile source---->(correct output) to oledb destination
Flatfile source---->(error output) to flatfile destination
This is the package task.
Now I have Servername,Databasename,flatfilesource name,flatfile destination name
These are all the connection strings which are placed in SQL table(SSIS_Configurations)
But when I need to change the database name and flatfilesource name,I updated at the backend SQL table((SSIS_Configurations).
But when I open the package it is still pointing to the old database and flatfilesource name.
How should I proceed further?? It's very urgent.Please help.
Thanks in advance.
-Nisha