Viewing 15 posts - 11,506 through 11,520 (of 13,877 total)
i can't see my variable updated with the value from the result set
What method are you using to check the value of the variable after the update?
March 23, 2011 at 10:36 am
1. This is a 2-year old thread.
Damn, missed that!
March 23, 2011 at 4:07 am
KrishnaChaitanya (3/23/2011)
I have an SSIS package which loads data into SQL server database. In the excel file, one of the column contains big integer values (e.g: 5012170). When the SSIS...
March 23, 2011 at 2:25 am
Tom Van Harpen (3/10/2009)
I have a staging table and the production table. I use a conditional split after a merge join (left outer) to determine if the row exists in...
March 23, 2011 at 1:33 am
I'll bet you're hoping that the input file won't get a load of extra columns added any time soon!
Too bad we can't write user-defined functions in the derived column editor...
March 23, 2011 at 1:21 am
Please post the full text of the error.
Which component is the cause of the error?
Please post the formulas for the expressions you have used.
--Edit: for those who are too lazy...
March 21, 2011 at 1:23 pm
I agree with all that, except that this looks like an ActiveX DTS script - is that correct? If it is, a straight rewrite in C# is a waste of...
March 21, 2011 at 9:19 am
You haven't really answered the question - please look at it again. There is an article here which may give you some useful information about query analysis.
March 20, 2011 at 12:36 pm
Or you could execute the SQL Agent job from a batch file instead - something like:
osql -E -Q "msdb.dbo.sp_start_job N'MyJob'"
March 18, 2011 at 8:49 am
It seems that Powershell can do it too. See here.
March 18, 2011 at 8:29 am
I suggest that you start editing your query manually & testing the results in Management Studio. Query builders can get you only so far.
March 18, 2011 at 6:30 am
Yes, SSIS still uses this archaic form of not equals
Not that archaic ... so does C#.NET 🙂
March 17, 2011 at 6:37 am
OK, simpler version:
public void Main()
{
...
March 17, 2011 at 2:31 am
If possible, I would approach this slightly differently.
1) Set up your trigger to write data to a 'pending' table every time there is an update.
2) Create an SSIS task to...
March 16, 2011 at 10:49 am
Not quite.
You know that for some c.chg_ref_num, the filtering works as expected and for others it does not.
The suggestion is to find one that works and one that does not...
March 16, 2011 at 9:27 am
Viewing 15 posts - 11,506 through 11,520 (of 13,877 total)