I created a wrapper to a WCF web service that is returning many datasets with hundreds of columns. The destination database schema matches the source schema exactly. When i make the connection on a ADO.NET destination object to my database
it auto-generates my list of columns. I understand that the script component could output anything so it can't autogenerate at this point, but is there any way to copy and paste the Column definitions from somwhere else and paste them in? I'd like
to avoid spending hours entering all these manually.
View Complete Post