[SQL 2012] SQL 2012, DB2 and SSIS |
- SQL 2012, DB2 and SSIS
- cluster install fail to validate ip address
- SSRS - exporting euro currency formatted text field to xlsx
- Passing a variable to an AS400 server using an OLE DB connection in SSIS
| Posted: 09 May 2013 02:24 AM PDT Greetings,We are going to a new server (Windows Server 2012) with SQL 2012 from SQL 2005. We have the DB2 client installed and a linked server configured in order to use OpenQuery to import data, which we do using SSIS. The problem is that, in the new environment, all the string data is now being seen as Unicode. This creates a huge hassle updating the dataflow tasks in the import package by having to add a Data Conversion transform and re-map all the fields.Does anyone intimate with the DB2 client and SQL Server 2012 know of a setting or change in the DB2 client or linked server configuration in SQL Server 2012 that might cause this change? I am not the one who installed the client or configured the linked server and so want to pass along anything I can to our DBA folks to get this resolved. Thanks. |
| cluster install fail to validate ip address Posted: 08 May 2013 07:36 AM PDT Doing first 2012 active/passive cluster install. On the screen which looks the same as 2008 where it needs to validate the cluster network I put in the IP I was give to link to the sql instance name. It fails and tells me it can not validate the ip address. I can't even ping the IP from a command prompt. Am I missing something, I don't think this will work and validate if I can't ping it. |
| SSRS - exporting euro currency formatted text field to xlsx Posted: 08 May 2013 10:53 PM PDT Hi, We have just migrated to SQL 2012 and are experiencing the following issue with exporting SSRS reports to xlsx.Text boxes formatted as Euro currency display in SSRS with the Euro symbol but export to xlsx as pipe(|).A point worth noting is the £ and $ currency formats export to xlsx without issue.Has anyone hit upon the same issue and/or knows of a fix?Thanks in advance,Stuart |
| Passing a variable to an AS400 server using an OLE DB connection in SSIS Posted: 08 May 2013 05:31 AM PDT I am attempting to pull some data via an SSIS package from an AS400 database. The time on the AS400 is stored in a different format (ex '2013-05-04' would be stored as 1130504). I have a sql task that executes a stored procedure that gets the date in the correct format I need and stores it into a variable. However - when I create a data flow task and go into the OLE Source and choose the sql command text as the data access mode - I am getting errors.select customer_number,customer_type,mail_type,last_change_date,customer_class,address, city,zip,post_codefrom customers where last_change_date > ?I get the following error:SQL0313: Number of host variables not valid.I have set the variable up and have passed it along - but it is not liking it.So does anyone have any experience with this when querying an AS400 box?Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment