no other tasks..only database restore is running on the server,also .bak file is in local network machine.

hi Sean Lange,

I want first row(column name) of excel as one comma separated string in sql .number of columns in excel will be dynamic.for...

after installation of msaccess12.0 driver its working...:-)

MS office 2007 or 2010?

windows 7 62 bit ?

Please guide me ....

is it working for anyone .

loading data in sql server 2008 r2(64 bit) from file(excel 2007,text file) using sql.....

I already tried this one lokesh....

but no change...

no excel is not open,and the path also correct.

i run the following code

EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

After that it shows

Msg...

its showing error

Msg 7302, Level 16, State 1, Line 1

Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

In some websites i seen that 64 bit is only from MSoffice 2010.But I'm using 2007 so it's 32 bit right.

and OS windows 7 (64 bit)

SQL SERVER 2008 R2(64...

thanks ....

yes.. i want Jan 10 + Jan 11 + Jan 12 + Jan 13 like this...

thanks

Rahul

thanks for quick reply...

but my requirement is like

I'm getting

month sales amount

January 1234

February 3232

January ...

for example,

i have time dimension,product dim and sales fact .

when i try to select month and sales amount, i am getting repeated months( i.e if i have 4...

use protection level as encryptallwithpassword and give password...it works for me...but i tried without any package configuration...hope this will work...

I have changed mstdc security options its working now..

but another issue..

in that i'm accessing data which is populated by first data flow task in second data flow task ...it get...