dbTalk Databases Forums  

Dynamically Create SQL Fields in SSIS 2005

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Dynamically Create SQL Fields in SSIS 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Dynamically Create SQL Fields in SSIS 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Matthew Wieder
 
Posts: n/a

Default Dynamically Create SQL Fields in SSIS 2005 - 10-23-2008 , 02:45 PM





How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #2  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM





The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #3  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #4  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #5  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #6  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #7  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #8  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
  #9  
Old   
Todd C
 
Posts: n/a

Default RE: Dynamically Create SQL Fields in SSIS 2005 - 10-25-2008 , 08:27 AM


The Import/Export wizard in SQL 2005 might be of use there in that it should
be able to read the meta data of the source and recreate it in the
destination, if everything (data types) is a good match. However, once
created, the package will be static. You could not expect it to be run again
AFTER making changes to the source meta data and have those changes
propagated to the destination.

Sorry, SSIS is not that smart.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Matthew Wieder" wrote:

Quote:
How would I go about creating an exact replica of a dBase file as a SQL
table? Using SSIS, I can create the data source from the dBase file, but it
will only let me import into a SQL destination if the table is defined and
the columns match up. How can I dynamically create the needed SQL structure,
so that it is created automatically based on the columns which exist in the
dbf file?

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top