append data from a text file

How can I append data to an existing SQL Express table from a text file? The file contains over 50MBs of data. This will be a recurring task so naturally I would like to automate this. I am familiar with programming VC++ and VB but am not sure where to begin.

Since it's a larger file, you could use the BULK INSERT command:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp

Or you could use bcp from a command line:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp

Hope this helps,
Josh Lindenmuth

App.config?

Hello All,

I am trying to use a custom C# dll from within a script task. The C# dll relies on the Enterprise Library 2.0. Where do I put the enterprise library configuration when I am debugging a package and then when I have the package in production. I cannot find any documentation anywhere on this.

Thanks for any help,

Justin

You need to edit:

DTExec.exe.config|||

Hi Jamie,

Thanks for the quick reply. Will that apply the config to all packages? If so, is there a way to supply a config file for a specific custom dll?

Also, do I need to put the same config in all 3 of those files?

Thanks,

Justin

|||

jechternach wrote:

Hi Jamie,

Thanks for the quick reply. Will that apply the config to all packages?

Depends how you execute it. DtsDebugHost.exe is what runs the packages in BIDS. dtshost.exe is what runs packages executed out-of-process from the Execute Package Task. Dtexec.exe is what is used at all other times.

jechternach wrote:

If so, is there a way to supply a config file for a specific custom dll?

Dunno. I don't fully understand this stuff in all honesty. Hoepfulyl someone else will.

jechternach wrote:

Also, do I need to put the same config in all 3 of those files?

Thats what we did on my last project and it worked well!!

-Jamie

|||

Jamie,

Thanks again. You have helped immensely.

I found this blog article about configuring biz talk with config files per custom dll, maybe SSIS was implemented the same way.

http://blog.magenic.com/andym/archive/2005/05/02/732.aspx

Thanks again,

Justin