Viewing 15 posts - 10,906 through 10,920 (of 13,872 total)
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you are prepared to venture...
February 2, 2012 at 6:42 am
So you are just ignoring almost all of the advice everyone has given you and still asking for help?
If you are not prepared to listen, or at least to...
February 2, 2012 at 4:37 am
Not sure, but have you tried using an expression, rather than parameters, to do this? Then you can quite clearly see where your variables are going.
You could also try something...
February 1, 2012 at 1:06 pm
rishiextc (2/1/2012)
1. SET IDENTITY_INSERT Table_name ON
2. INSERT into Table_Name (Column_1, Column_2......) Values (Value_1, Value_2.....)
(make sure while inserting you specify name of required...
February 1, 2012 at 7:34 am
That's how IDENTITY columns work. Read more here.
If you really want to reset the seed value, read up on DBCC Checkident.
February 1, 2012 at 6:54 am
If you rewrite your proc slightly to use dynamic SQL in the non-validating bits, you can get round the validation issues.
February 1, 2012 at 4:59 am
Once you've built your dynamic SQL string, try doing a straight
select @sql
before executing it. That should allow you to see where things are going wrong.
February 1, 2012 at 2:50 am
No problem.
I was responding to this statement:
I generally use SQL2K8 and i'm used to the format on it. Unfortunately the company i'm working for are on 2K5 and they're not...
February 1, 2012 at 2:28 am
What is there about your proc which works on 2008 and not 2005?
February 1, 2012 at 2:19 am
I explained the behaviour of STR() (or so I thought).
For your purposes, it is not suitable. If instead you cast your variables as, say, varchar(30) and then print them, you...
January 31, 2012 at 9:35 am
krishnaprasad14 (1/31/2012)
[For example, today we got 3 records into Unmatch obkect and tomorrow may be...
January 31, 2012 at 6:19 am
Koen Verbeeck (1/30/2012)
Sri8143 (1/30/2012)
I am using ssis not ssms ....and they want to do it thru ssis ..
Use an Execute SQL Task to create a backup of the database.
Use another...
January 30, 2012 at 6:47 am
I'm afraid that I don't 100% understand what you are doing. But as you are operating on a single server, I would be tempted to do the whole thing in...
January 28, 2012 at 12:18 pm
So is it the case that you only ever want to insert new data and that you are not worried about updates?
Is the PK ID an identity column? Just wondering...
January 28, 2012 at 10:06 am
Koen Verbeeck (1/26/2012)
Just split the datastream into two datastreams by using the multicast component. That way you'll have two outputs. Connect each of them to the corresponding file.
Or maybe you...
January 26, 2012 at 12:56 am
Viewing 15 posts - 10,906 through 10,920 (of 13,872 total)