Importing data from multiple sheets in an excel file with same schema into single destination table in sql server

rated by 0 users
This post has 28 Replies | 3 Followers

Points 35

chozhanvijay replied on 10-08-2009 10:15

rated by 0 users

Has tried removed the $ in the '01$' too by the following code

Dts.Variables.Item(

"uvWorkSheet").Value = Dts.Variables.Item("uvWorkSheet").Value.ToString().Replace("$", ""

)

Still throws the following error

[EX_SRC Get Each WorkSheet Data [1]] Error: Opening a rowset for "'01' " failed. Check that the object exists in the database.

| Post Points: 5

Points 35

chozhanvijay replied on 10-08-2009 10:19

rated by 0 users

FO your information......AM having Excel 2003 with SP 3 ....IS it anything to do with excel saving format too?...like 2.0,3.0.....any specification for this

| Post Points: 5

Points 35

chozhanvijay replied on 10-08-2009 13:01

rated by 0 users

Gotchaaaaaaaaaaaaaaaaaaaaaaaa :)

We have to remove the space in the sheet name.Use this code below in the script editor before assigning it to Dataflowtask which is inside the for loop ..

Dts.Variables.Item(

"uvWorkSheet").Value = Dts.Variables.Item("uvWorkSheet").Value.ToString().Trim()

Cheers

Vijay