Thanks so much for the reply! That is more than enough information to get me started. I'll be sure to post an update on what we've done to...

Weird, I show that it's been uploaded, but I did it again. Let me know if you still can't see mkt.zip.

Why doesn't 6/6/2079 make sense?  Our date table (which comes from our ERP) currently only has dates until September.  The 6/6/2079 date ensures that situations such as orders being placed past...

The fiscal calendar is passed in through our ERP to our 400.  These fields are in the [ETL].[Transform_DimDate] table. 

Jeff, Are you talking about the first week of the calendar year?  If so, that falls into week 14 for us, and that week starts on Sunday, January 31st, and...

The first table, dbo.DimDate, is created in databaseA, we'll name it, and the second table, ETL.TransformDimDate is created in databaseB.  Let's say we have a row where...

Right now, I manually open the file and wipe out the column names.  I'm not sure if they will always be saving the data this way; this month it was...

I've finally gotten a job that works!  I have three T-Sql steps:

1. Create the table

2. Load the table

3. Delete the file out of the directory

A few questions that...

I am attempting to use Bulk Insert (statement below).  When I run it in Query Analyzer, I'm getting an error: Invalid number of columns in format file 'C:\documents and settings\datamining\my...

Okay I tried to run from the cmd line, and I got the error "Unknown command 'and' on command line".  The path to where my txt file is at is:

C:\Documents...

Vivien, I have also been working on implementing your solution.  I have gotten the T-sql step 1 working, but on step 2 it is hanging when the job runs.  I...

Our table names should be identical to the files, such as 2007Dec08Sprint, with the month and year changing as needed.

I created an ActiveX script, which I have pasted below.  ActiveX...