Thanks for the suggestion, i'll look into that but can you guide me exactly how to go about it

kind regards,

Affan

Thanks Johnny,

the package name was wrong as the font was very small and i could not catch the spelling mistake 🙂

Kind Regards,

Affan

But when i set the length to 4000 through tranformation, shouldn't it take the column length as varchar 4000???

Kind Regards,

Affan

What if my sheet name varies??

Secondly if have changed the length thru transform to varchar 4000 but it still giver buffer overflow error

Regards,

Affan

I have found the OLE error, it was due to wrong destination server name.

Regards,

Affan

SQL Server 2000 Personal Edition and SP2.

Now error has been corrected but now i am facing another problem that

I have a server the package resides and i am exporting...

But the problme is that when i remove the place holder/parameter it works fine other wise it generates error.

Also datatypes for both tables are exactly same.

Generally when this error occurs...

I was thinking of building the whole string using cursor as i'll be building the SQL string which require , as well.

so string will be dynamic toatlly.

Secondly i am just...

Did you try upsizing wizard of Access??

A While back i tried that and it worked fine with me??

Its a simple straight forward wizard

Regards,

Affan

Thanks Andy,

Can i get the details that how to setup the replication through FTP as i am new to replication.

Regards,

Affan

Yes Steve is correct that data generators works for some scenarios.I know a tool called DataFactory but it has a price tag we have found some difficulties while generating data...

Please explain

"Use paramater substitution so that the actual statement text remains the same."

Since i will be pulling all the text from a table and it will remain the same.

Secondly i...

I have checked all this stuff as it was working perfectly till now and suddenly it has started throwing the error which worries me a lot.

Regards,

Affan

Thanks Chris,

Since i will generate all the queries by looking at the metadata so i will have to generate those queries at run time so thats why i need to...

Thanx for replying,

So what i was thinking that i will create the proper relationship and then GUID will help me as unique column which i will not need if i...