I'm new to ssis and need some help. I have a csv file I need to use as a parameter to get some information and then update it.
Here's how it looks in crystal reports...
SELECT "Order_Master"."ORDNUM_10", "Order_Master"."TYPE_10", "Order_Master"."STATUS_10", "Order_Master"."CUSORD_10"
FROM...
Our company for years have used a text field as a way of adding more information about the customer. There are 3 digits in the code and the depending on the character and the position lets us know some information about the customer. Recently I found a way to add custom fields.
Now I would like...
Hi Everyone,
I trying to add data to the table based on query of the same table. Basically we have a several thousand entries with 21 in the option filed and want to make duplicates of the entries with 50 in the option field and change the string in the description field to something else...
Hi Everyone,
I'm new to SQL and have been tasked with creating an "app" where the user can run a query to our 2012 SQL server with the click of the mouse. Our old db was Pervasive SQL and there was a way for the users to access the db on their desktop...sometimes with horrible results.
What I...
HI Everyone,
Currently the user types the parameters into the report manually. I want to convert the report to gather the data from the fields of the .csv file. I've added to the .csv to crystal report what I don't understand is exactly how to make it read the values in the place of the...
My company has tons of PDF drawings listed in folders by sales order number. I already have script to access the information, but it returns a basic folder listing back. I would like to modify this to return a webpage which will allow me to put other information in the page. This is what I have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.