I create one file group for each file. Actually that kind of issue will give you error right away. My script ran for more than a day without any output....

Hi Bhuvnesh,

Thanks for the reply.I didn't specify any range for January data. So it went to the last partition. Ideally, if I create a partition for january.. the data in...

Hi,

THanks for the reply. You correct I am trying to do a split of range. But the problem I am facing is SQL server is unable to move the data...

Hi,

I think this will help

SELECT CONVERT(VARCHAR(10), GETDATE(), 112) + Replace(CONVERT(VARCHAR(10), GETDATE(), 108),':','')

Thanks,

Swaroop

Hi,

You can use the below link.. The first link I got after googling. 😉

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

I normally change the datatypes in excel itself before importing. So that I can get...

try this

=round(Fields!MegaBytes.Value,0).ToString() & " (" & (round(Fields!MBPerSub.Value,0).ToString()) & " )"

If I take backup of the filegroups and after taking backup I will do a merge on the table for September. How to restore after that.

Thank you Vishal

Hi,

Not sure if you have tried using Left Join instead of inner join.

You can put an expression in the report cell to check for the valid value from either Table2.Name...

It is working with DB tables as well.

Let's wait for the original poster to respond.....

Here you go ..

I am not sure how to upload the package and the excel file to this thread. would you mind sharing your email ID!!

Hi,

I don't know what error you are getting. I just tried your scenario by putting 2 excel files in the source folder with data in Sheet1 and Sheet2 respectively. It...

Thank you Jannie for your valuable inputs.

Can you use while loop?