View Complete Post
Hi I have to transfer 12 tables from say databse 'a' and 10 tables from database 'b' using ssis package to database 'c' and i have to rename the all the table in database 'c' with '_bak' at the end of all table's.Table name are same i.e
databse 'a' have table's
1. transaction 2. suplyer etc and
databse 'b' have table
1. deliverd 2. status
then database 'c' already have those table from 'a' and 'b'
now they have to rename by _bak and copy againg those table from database 'a' and databse 'b' to database 'c'
I have a directory with 200+ txt files to import into SQL tables in a database. Each file name is the exact table name in the database(without the file extension, obviously). I am looping through each file with a for each loop and a variable is mapped and
set in the source connection properties for the Expressions -> ConnectionString property, so each name will go into that variable without the file extensions, correct? Now, I set the variable name to the table name in the destination for the table
name under "Data Access Mode", but it is giving an error...do I have to assign variables to each part, (Connection String and Name)? Does anyone have a quick setup for this?
I need to re write this query with CTE's to reflect differences in DNC ($$) between my @mindt and @maxdt
do I need to show a DNC @ MIN Date and DNC @ Max DT so i can calculate the differerence...can you help?
declare @mindt datetime
declare @maxdt datetime
set @maxdt = getdate()
set @mindt = getdate()-14;
With itmlvl as (
FROM GEPRS_DNC..T_REBATE r
JOIN GEPRS_DNC..T_REBATE_PERIOD rb
ON rb.REBATE_ID = r.REBATE_ID
--GTR, SSR: from T_REBATE, T_REBATE_PERIOD, and V_ITEM_SPLR
GTR_SSR AS (
, rb.DSCR, rp.AMT
, rp.EFF_DT, RP.END_DT
from geprs_dnc..t_rebate rb
assume i have created a temp table, #t1 and after completion of query execution in the sp i can delete it from db.
in multi user enviorement, each user who acess that sp creates a temp table, i know teml tables has a structre #_______________<number> so when each user access this sp, does it create a seperate temp table for each call?
I've a scenario in which i need to map my xml file to multiple sql server tables, maintaining Referential Integrity.
Below is my sample xml structure
<Hdr_ID>ID of the above record</Hdr_ID>
as u can see above, 1 parent record has 2 child records. So i need to save the parent record first, based on the ID which is generated automatically, i need to save my child records into the Detail table. I've searched everywhere in google, but couldn't
get a solution yet.
(I had done this sort of thing in vb.net but now my job is to do it using SSIS) :(
Can you gurus help me in achieving my task.
Thanks in advance.
We have a huge Database with more than 100 tables , more than 150 SPs.We are 10 members and we will be creating/deleting/updating SPs , functions, views, tem tables everyday. Actually at the end of the day, we have to send the scripts
of latest SPs,functions,views,Temp tables to the server. So far what we are doing is we manually go to the SQL server Scripts Wizard and selecting one by one all the SPs,functions,TTables and views. Is there any quicker way to take the changed stuffs
instead going manually?
I would like to identifying the source & destination tables of the data flow or the transformation task.
I need to create a custom component which i can put into existing packages which can do some validation.
Please suggest ways i can accomplish this.