Viewing 15 posts - 121 through 135 (of 410 total)
thepotplants (6/22/2008)
Before a bunch of sanctimonious pricks wade in and tell me to learn how to use SSIS properly. I'd like to add that I could have perfomed this function...
June 22, 2008 at 11:51 pm
hey venki,
Once more, I misunderstood you...
You have a SP that inserts data from one table to the other. I didnt realise that you are trying to pass parameters, and work...
June 22, 2008 at 11:41 pm
Hey,
SSIS does not come with your particular version of SQL (Express)
June 22, 2008 at 11:34 pm
Welcome to SSIS.
First off, buy a SSIS book and play with the samples. Its actually not that difficult.
but for your immediate requirement, I would suggest that you switch on package...
June 20, 2008 at 6:49 am
Welcome to the SQL community, and a hearty welcome to SSIS.
First off, there is no need for a custom program to import the excel, thats just overkill, SSIS will import...
June 20, 2008 at 6:45 am
Gotta say that I have never tried that
Good luck man
June 20, 2008 at 5:19 am
In your case, I would still go for SSIS merge join and derived columns. But its gonna be quite some work changing it by the sounds of it.
Why? Because everything...
June 20, 2008 at 5:18 am
uhmmmmm, why dont you have a SQL server agent job which checks for the data marked as 'X'
Then you can have it retry lets say 100 times.
If it finds it,...
June 20, 2008 at 5:10 am
Didnt know that you have Integration Services with SQL Server Express
June 20, 2008 at 5:08 am
You misunderstood me.
I meant that you are currently using a stored procedure and deriving NAME from Firstname and Surname.
If you do a merge join you can achieve the same by...
June 20, 2008 at 3:57 am
For sure, lesson learnt.
Worst behind it all is that I am not a DBA, and only know enough to be slightly dangerous...
Yeap, South Africa. Get me not wrong, I am...
June 20, 2008 at 3:00 am
Its a good question, and this posting actually reminded me to send the follow up mail to them.
Sometimes you are restricted by some things that you really take for granted.
When...
June 20, 2008 at 2:06 am
I am misunderstanding you
You want to convert 27.12.2008 to numeric. Why would you wanna do that?
Unless you mean that you want to convert 27.12.2008 to 27122008, in which case your...
June 20, 2008 at 2:00 am
Fully agree Gila.
So I go on site to my support guys for my weekly pow wow, and tell them that I am ready for the next phase of our implementation,...
June 20, 2008 at 1:53 am
So in other words, in SSIS after you do the transfer database, have a execute sql task which does the change in compatability level.
Sounds relatively automatic and straightforward
~PD
June 20, 2008 at 1:43 am
Viewing 15 posts - 121 through 135 (of 410 total)