What deployment model do you have configured?

Are you sure someone didn't remove or move the file?

Make sure you don't have auto shrink enabled. It adds latency to have to expand data and log files. If they grow to a size to handle loads don't shrink....

I use Red-Gate SQL Prompt. It has some nice enhanced Intellisence like functionality I really like. It collects Meta data when you connect to a linked server. It fills in...

This is caused by the flat file connection manager definition of the column being too short. Open the Package/Project in SSDT and Open the Flat File Connection Manger and select...

What's the error?
What's the result of this query?

   SELECT
     ...

If indexing will enhance the performance of your intermediary staging tables then it's a good idea. Without a lot more information no one can give you meaningful advise. Try testing...

@Kd11,
Cursor or not? I vote not. There aren't many problems that can't be solved without using a cursor. Here's a solution using UNPIVOT.

DECLARE @pvt table(sName char(3), sDate date,...

If it's a text file try the sqlcmd command line utility.

Backup to what format?

Are you asking about exporting the data in tables to text files? It's easy in SSIS or from the command line. Can you describe more what you are trying to...

If you post an image of your sample data, I will have to type in a create table statement (and guess the data types), and insert statements from your image....