Search for SSIS and Rownumber to get some ideas.

This may be promising: http://consultingblogs.emc.com/jamiethomson/archive/2005/02/16/1025.aspx

It seems the order of the records in the spreadsheet determines the relationship between the...

What is better?

More robust? I'd say more robust is always better.

Faster? maybe, I am going to improve the efficiency of a 30 second procees that runs on the overnight...

Greg Charles (11/25/2009)

---

We want to limit the number of holes in the firewall so we've decided against linked servers and restricted data movement to pushing data into the DMZ servers...

This may be a good resource.

http://msdn.microsoft.com/en-us/library/bb522901.aspx

>>If the file is imported successfully then send email with message: The file is imported

This may help or at least give you the proper terminolgy for further research on your...

Do you want to insert the file name in every line of data being imported? Use the above mentioned variable in derived column within your data flow.

Greetings,

My time is short but I will give you the quick outline.

-create a user defined string variable to hold you file name

-Go to the properties of the for each loop...

I won't be able to change the format of the file, I can change the SQL that determines the data in the file. Can I remove the unicode characters in...

First off I have no experience with either log-shipping or replication.

>>We have no control what-so-ever over the customer's databases, that is what is worrying me.

I'd be worried. Consider the...

How much administrative control do you have over the remote servers? I would think log shipping or replication would be difficult to manage if there wasn't strong control over the...

http://www.sqlservercentral.com/articles/Administration/pickingserviceaccounts/2351/

Temp tables can be good for design flexibility and ease of understanding. Take two situations that both return the correct results: a series of temp tables or a single complex...

emily-1119612 (10/23/2009)

---

How is action time accrued?

I meant "How is vacation time accrued?

How is action time accrued? Is it based on employment start date, years working at the firm or other factors.

Generally I would think about it like this. An employees' available...

>>Can anyone please help how to write a batch file to get an email in this manner .

You can use SQLCMD from a batch file (.bat) which will then...