shank-130731 (12/27/2012)

---

I have 2 SQL servers: SQL_Local and SQL_Remote. I have SSIS on SQL_Local. I want to transfer records from SQL_Remote.Customers into SQL_Local.UPS only when a record is inserted into...

There does appear to be OLEDB providers for PostgreSQL ( http://www.postgresql.org/about/news/1153/ ), but that doesn't answer your immediate question. Sorry I couldn't be more help.

Rob

I don't have your data, so I can't find the data type error. That SELECT probably gives a good starting point to start examining your DW source data.

HTH,

Rob

Jon Jaroska (12/27/2012)

---

Visual studio is installed on the server where sql server resides. The DSN is setup on the machine and running the package in debug mode works. I...

From you're DDL, I can't see the FK relationship, so I'm not sure how you're joining your two tables. After you've done that, you can take a look at...

Mac1986 (12/27/2012)

---

Thanks Rob..Is there a way to that user selects a date in the top filter and in the respective WQ.WorkQueueRunGroupRunID assigned to that date gets selected in the where...

Jon Jaroska (12/26/2012)

---

I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there...

Please don't post the same question in multiple forums as it just splinters your responses. See my reply regarding data type issues here: http://www.sqlservercentral.com/Forums/Topic1399615-147-1.aspx

Rob

So what was the issue? I'm guessing you weren't SELECTing apples to apples, but if you reply to your own post and tell the solution rather than saying disregard,...

Are you able to manually access the underlying DW tables (located in the BI_Inspecao database)? The error seems to suggest that you've got a bad value in the datawarehouse....

Mac1986 (12/22/2012)

---

All I want is a filter in the report, where users can choose their date, then when they push the ViewReport option they should see all the 58 sessions...

raffaelet (12/24/2012)

---

Hallo

has anyone experienced an alternative to the standard SSRS designer?

I mean something more similar to an Adobe Illustrator, with more control over sizing and positioning, grouping, and locking.

And a...

ajay6789 (12/24/2012)

---

Query:I delete a table in sql server 2008,and,i do not want this entry to go to our ldf(log files).In this way,my purpose is that,the size of ldf should remain...

No real...

MattieMich7 (12/19/2012)

---

I've attached a screenshot of a selection of records from a staging table I'm using in my SSIS package. I need to iterate through these records and capture...