Showing posts with label load. Show all posts
Showing posts with label load. Show all posts

Wednesday, March 21, 2012

Need basic.

Hi All,

Can this be done and if so can you give a bullet list of the steps need to accomplish this.

I need to load a bunch of files into a stagging table. Need to loop through the files and load them.

Thanks,

Michael

Essentially you're looking at is the following:

1) A for each container using the for each file enumerator.

2) Within that, you'll need to assign the filepath to a variable

3) Within the container, create a dataflow task with a flatfile source and a sql server destination, mapping the columns.

4) dynamically change the connection string of the flatfile source (properties/expression)

Hope this helps

|||

Thanks Rick,

That is a good start, I will see how far I can get.

Michael

Wednesday, March 7, 2012

need a remote bcp or similar utility

We are looking for a way to load a database with bcp during an install. The catch is that the input file and the install (which would kick off the bcp load) can be on a different machine than the database (and the bcp.exe). Any ideas?
Kevin,
for bcp.exe it doesn't matter whehter the data files or database servers are
remote or local. So, you should be able to load your data with no problem.
Tengiz Khartishvili
SQL Server Storage Engine
This posting is provided "as is" with no warranties and confers no rights.
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:9D3090CE-91A8-42B1-8C40-928FC0DC33EC@.microsoft.com...
> We are looking for a way to load a database with bcp during an install.
The catch is that the input file and the install (which would kick off the
bcp load) can be on a different machine than the database (and the bcp.exe).
Any ideas?