DTS limitations  
Author Message
xmasangel





PostPosted: Mon Dec 29 14:38:42 CST 2003 Top

SQL Server Developer >> DTS limitations

I have a table with all the header information for an
order. All that is not included in this table is
information pertaiining to order lines of the order.

The tables are relational so the header table has all
numbers in it. I need to export this information for a
non relational database so I need to join all tables
related to the header table.

I have 12 tables joined and it exports the data fine. I
am exporting with comma delimited.

I created this DTS package using the wizard.

When I go to the design of the package to edit I click on
the properties of the connection arrow. Click the
Transformation tab and a message box pops up saying 'some
of your transformations refer to columns that do not
exist in your source or destination' I have 3 options:
1- remove invalid transformations
2- change source/destination
3- remove all transformations and redo auto mapping

No matter what I click I lose all the mappings.

I have about 35 columns of data I need exported. Is
there a limit on the amount of columns you can export?

Any other ideas of why this is happening?

Thanks

SQL Server147  
 
 
brian





PostPosted: Mon Dec 29 14:38:42 CST 2003 Top

SQL Server Developer >> DTS limitations Sorry ment to post in the DTS area- please ignore
>-----Original Message-----
>I have a table with all the header information for an
>order. All that is not included in this table is
>information pertaiining to order lines of the order.
>
>The tables are relational so the header table has all
>numbers in it. I need to export this information for a
>non relational database so I need to join all tables
>related to the header table.
>
>I have 12 tables joined and it exports the data fine. I
>am exporting with comma delimited.
>
>I created this DTS package using the wizard.
>
>When I go to the design of the package to edit I click
on
>the properties of the connection arrow. Click the
>Transformation tab and a message box pops up
saying 'some
>of your transformations refer to columns that do not
>exist in your source or destination' I have 3 options:
>1- remove invalid transformations
>2- change source/destination
>3- remove all transformations and redo auto mapping
>
>No matter what I click I lose all the mappings.
>
>I have about 35 columns of data I need exported. Is
>there a limit on the amount of columns you can export?
>
>Any other ideas of why this is happening?
>
>Thanks
>.
>
 
 
oj





PostPosted: Mon Dec 29 14:48:16 CST 2003 Top

SQL Server Developer >> DTS limitations Your table schema might have changed. #3 sounds like the route to take. Also, I
suggest you take a look at www.sqldts.com. There is quite a bit of info on dts.

--
-oj
http://www.rac4sql.net




> I have a table with all the header information for an
> order. All that is not included in this table is
> information pertaiining to order lines of the order.
>
> The tables are relational so the header table has all
> numbers in it. I need to export this information for a
> non relational database so I need to join all tables
> related to the header table.
>
> I have 12 tables joined and it exports the data fine. I
> am exporting with comma delimited.
>
> I created this DTS package using the wizard.
>
> When I go to the design of the package to edit I click on
> the properties of the connection arrow. Click the
> Transformation tab and a message box pops up saying 'some
> of your transformations refer to columns that do not
> exist in your source or destination' I have 3 options:
> 1- remove invalid transformations
> 2- change source/destination
> 3- remove all transformations and redo auto mapping
>
> No matter what I click I lose all the mappings.
>
> I have about 35 columns of data I need exported. Is
> there a limit on the amount of columns you can expa hr
>
> Any other ideas of why this is happening?
>
> Thanks