Viewing 15 posts - 31 through 45 (of 56 total)
Sorry about that...
My SSIS package pulls data from table (A) and inserts it into table (B) on another sql server.
Our users pull that data from table (B) into excel and...
December 2, 2011 at 8:57 am
Yeah!! that was it....
Thank you for pointing me in the right direction 😀
December 1, 2011 at 2:43 pm
I don't want to sound like an idiot but I'll go ahead and do that.
How do I
change your variable to use an Expression
Is that changed under the Data Type...
December 1, 2011 at 2:27 pm
Lets see if I can explain it right.
What I'm doing is pulling in data from another database using a SSIS package. In the source editor I'm using SourceConnectionOLEDB ...
December 1, 2011 at 2:04 pm
Hi
Thank for the response. I did add Derived Column but know all it does is add the column plus the date and time that is listed in my variable. I...
December 1, 2011 at 1:43 pm
Thanks to everyone for the replies. We found out that the table name was wrong. Once it was changed to the right database it worked. But everyone gave me other...
December 1, 2011 at 7:36 am
Thank you I tried the sp_refreshview hgvTimeDataFetchWithRates_Rosetta it stated that it completed but I'm still getting the same errors.
November 22, 2011 at 2:49 pm
If your asking am I querying a view for the SSIS package then yes I am.
November 22, 2011 at 2:26 pm
I wish it was that. I tried to remove the spaces with no such luck.
This is an image from the table that the view reads from (attached)
November 22, 2011 at 2:19 pm
Thank you for the fast reply. I added the Derived Column. I attached a screenshot of it. Do I take the date info from my script in insert it there?...
October 28, 2011 at 2:39 pm
Steve -
No real-time access to the production data is not a requirement. That is the good news out of all this. 🙂
The snapshot replication looks to be the way...
September 14, 2011 at 1:11 pm
Hi - No question is silly just my answer might be. 🙂
The IIS and SSRS are separate from the DB server.
September 14, 2011 at 1:06 pm
A BIG Thank you to everyone who responded all this information really helped us out.
Thank you again. 🙂
September 9, 2011 at 9:29 am
Thank you for reply - On our current sql cluster setup our admin made the Cluster name a server you can log into along with the two nodes. I was...
September 8, 2011 at 8:30 am
Thank you both I was able to get what I needed by using the Task and not Tasknote.
David
August 30, 2011 at 3:09 pm
Viewing 15 posts - 31 through 45 (of 56 total)