IMO, your suggested approach is not optimal.

A better model is one package per table, with some sort of controller/master package which executes them all.

If your loading methodology is similar for...

Any data that has already been lost during the conversion to SmallDateTime will...

First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.

It would probably be easier to use T-SQL to get your data into the required...

1) Use a delimiter which does not appear in your data.

2) Use SSIS 2012 onwards. See here.

JoshDBGuy (12/10/2014)

---

Grant Fritchey (12/10/2014)

---

Small company or not, I strongly recommend putting process for getting stuff out to production into place and following it religiously. The last thing you want are...

This is not best practice – you should consider moving the files to a 'Processed' folder after they...

You could avoid the whole issue (assuming the import folder only ever contains the files to be processed, because processed files are archived) by using a FOREACH loop selecting files...

What is the error?

Is the server in the same domain as the machine she's trying to log in from?

butcherking13 (12/9/2014)

---

She is currently developing stored procedures to automate several reports. Not sure what they have planned for her down the road.

She has asked for sys admin rights because we...

butcherking13 (12/9/2014)

---

Hello, I was looking for suggestions from the tenured DBA's here as I am a very new junior DBA.

I work with one developer who has a few years experience....

Do not use SET IDENTITY INSERT ON – that is telling SQL Server that you wish to override the auto-increment for some reason. So given a table X

Id int identity...

Can you write out the desired results, based on your sample data?

If you could provide your input data in consumable (ie, runnable in SSMS) format, you will be more likely...

What's your specific question please?

Don't...

See here.