Viewing 15 posts - 1 through 15 (of 45 total)
Also please note I dont want it to be a table. Thanks.
February 10, 2012 at 3:37 am
i have created another variable called truncatetable and passed this as a variable to sqlstatementsource
September 9, 2011 at 10:03 am
where do i pass the table variable?...sqlstatementsource would be truncate table isn't?
September 9, 2011 at 9:49 am
kramaswamy (9/9/2011)
Hey there, saw you had sent me the email, dunno if that was before or after your last post. Do you still need any help?
no thats fine..ignore the package...
September 9, 2011 at 9:43 am
sorry another question ..part of same..how to truncate table before importing data into it..i would need some statement like truncate table @tablename..@tablename is a global variable
September 9, 2011 at 9:38 am
sorry i got that sorted, had to provide a default variable
September 9, 2011 at 9:29 am
i am uable to do that here, if u have any email address i can forward it to u
September 9, 2011 at 9:23 am
I somehow managed to get to the stage that it creates tables taking dynamic variable name. But i am getting the below error. I have made the tables already but...
September 9, 2011 at 9:08 am
please see the attached template, i have got problems with it..not able to get around my head
September 9, 2011 at 4:51 am
Okay, fair enough. Still doable with the same setup, but a bit more difficult.
Assuming the table definitions for all the tables are the same, just with different names, what you'll...
September 8, 2011 at 3:32 pm
You're saying that the data is not all going in to REPLON1.dbo.crm_staging?
So, for example, you'll have a table like REPLON1.dbo.crm_staging_UK, and another one like REPLON1.dbo.crm_staging_FR, etc...?
If that's the case, would...
September 8, 2011 at 3:15 pm
yeah u r right in ammending the script. Yes, all my markets are in the same sub-directory but the data is specific to each market. so when i am...
September 8, 2011 at 3:06 pm
no, the paths below:
o UK: \\viperlon1\_development\_live\import\UK\WEBITEM5Dailyo US: \\viperlon1\_development\_live\import\US\WEBITEM5Dailyo DE: \\viperlon1\_development\_live\import\DE\WEBITEM5Dailyo AT: \\viperlon1\_development\_live\import\AT\WEBITEM5Dailyo FR: \\viperlon1\_development\_live\import\FR\WEBITEM5Daily
are specific to each market. we need an object that has all markets together, and that needs...
September 8, 2011 at 2:52 pm
Viewing 15 posts - 1 through 15 (of 45 total)