Groups | Blog | Home
all groups > sql server programming > september 2003 >

sql server programming : How to update a DTS package?



Sender
9/22/2003 2:26:44 PM

[quoted text, click to view]

Sender
9/22/2003 2:28:02 PM
[quoted text, click to view]

What if , if earlier there were 5 columns in the view and now there are 20 ?
Do you think there is no need to change the package ?






[quoted text, click to view]

GB
9/22/2003 9:05:49 PM
Hello,
I created a DTS package to export data to flat file.
This DTS package based on a view.
Could you please give me a hint how
to update this package dinamically
every time when I update the view?
Is it possible from C# code?

Thanks,
GB

Yovan Fernandez
9/22/2003 9:14:26 PM
IF the package was created from a view when ever you change the view it
should also change the package since the package is looking at the object
(the view) to get its data. Unless you created the package using the source
code from the view then i suggest you rebuild the package to point to the
view to get its data.


Yovan

[quoted text, click to view]

AddThis Social Bookmark Button