tsanta, sorry for any delay!! have a browse and replace the print statement with other syntax.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=114315#bm116592

Hop it points you in the right direction.

Try this. I would like to take credit for this but I can't. Its a handy little bit of script that I lifted from a forum some time ago. Hope...

Excel attempts to be clever by recognizing dates and automatically formatting it to what the computers regional settings are.

So you have a few options –

a. Change the users regional settings...

Proclarity is a pretty good tool for a reasonable cost.

Do you use Global Variables? if not it might be worth looking at BOL

I always force imported files to have the same name everytime.

/******************************************************************************************************

** Check to see if a file exists

******************************************************************************************************/

DECLARE @chkfile INT

DECLARE @exists BIT

EXEC @chkfile = sp_MSget_file_existence 'C:\boot.ini', @exists = @exists output

IF @exists = 1 ...

You may want to check the DST packages to see if any of them re/process any shared dimensions.

When you re/process a shared dimension it becomes locked, meaning any other...

try previous link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832

it may help.

What about sending the results to another XL file that has has code in that will continue the loading at the click of a button.

I've had the same problem previously. The following worked for me - open the excel file and delete all the rows below your data. Hope this helps.

I would have done it this way just to cut down on typing - select left(datename(month,getdate()),3) + right(datepart(year,getdate()),2) . Does anyone know which performs better? my execution plan...

Try this – Don’t manually create the spreadsheet, let SQL server do it. Create the spreadsheet in your package and in your data pump task ‘Destination’ select to create...

Proclarity all the way, apart from the excel spreadsheets and soon reporting services. We use excel for flat bulk reporting and Proclrity for analysis and viewing KPI's, looking into RS...

In excel

Create a spreadsheet called screwup.xls

In MMC

Create a SQL server connection

Create a spreadsheet connection (who’s filename is the screwup.xls file)

Create the Transform data task, in the source type “select 'user1'...