Viewing 15 posts - 8,851 through 8,865 (of 13,876 total)
I am using the SQL server 2012 and Project Deployment model
So why are you using Windows Environment Variables then?
December 17, 2014 at 7:32 am
vipin_jha123 (12/17/2014)
My Concern is , is single DFT will take the Table name in both Source as well as destination dynamically and is dynamic column mapping is possible in...
December 17, 2014 at 4:21 am
koti.raavi (12/17/2014)
Can any one help me out how to execute 5 procedures in one procedure ...
December 17, 2014 at 4:16 am
The article is absolutely fine, though I would not categorise a CROSS JOIN as advanced.
AFAIK, the words CROSS JOIN can be replaced by a single , and all will...
December 17, 2014 at 3:31 am
To be honest, I'd be speaking to whoever has asked for these changes and telling them that they cannot go to production because of the change freeze.
It is then down...
December 17, 2014 at 1:07 am
SSIS does not really support dynamic columns. Do you have dynamic target columns too?
December 16, 2014 at 4:53 am
Why are you doing it like this and not using a flat file source?
December 16, 2014 at 4:12 am
Use source control.
At any time you want, you can compare your database schema with what is in source control.
If you want to find out who made a change to a...
December 16, 2014 at 4:07 am
vipin_jha123 (12/15/2014)
Hi ,Thanks for your suggestion about BIML.
Can I load the source and destination table name using BIML Dynamically ?
Regards,
Vipin jha
BIML generates packages, it does not load anything.
BIMLScript might be...
December 16, 2014 at 3:49 am
legeboka (12/12/2014)
I have SQL 2008, LAG wouldn't work
You realise you're in the 2012 forum? 🙂
December 12, 2014 at 7:37 am
Indianrock (12/11/2014)
December 11, 2014 at 9:38 am
First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.
No, that is what I wanted just the casenumbers.
Really? Your sample query includes this...
December 11, 2014 at 9:08 am
IMO, your suggested approach is not optimal.
A better model is one package per table, with some sort of controller/master package which executes them all.
If your loading methodology is similar for...
December 11, 2014 at 3:02 am
sunder.bugatha (12/11/2014)
save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.
Any data that has already been lost during the conversion to SmallDateTime will...
December 11, 2014 at 2:16 am
First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.
It would probably be easier to use T-SQL to get your data into the required...
December 11, 2014 at 1:05 am
Viewing 15 posts - 8,851 through 8,865 (of 13,876 total)