Viewing 15 posts - 91 through 105 (of 108 total)
Check you Excel if it really has Sheet1 present or not. Also try configuring this Excel as a source, may be the sheet you are referring is not available.
You can...
February 23, 2015 at 11:11 pm
Yes, you can do this in SSRS. Try using below query in your dataset and create a table in your report to display the output.
SELECT name, SUM(count), MAX(modified) as last_modified
FROM...
February 23, 2015 at 11:08 pm
sharonsql2013 (2/11/2015)
My Store proc has the where filter with an in clausewhere abc in (@xyz)
However while executing , Can I pass multiple values?
Exec usp.Planner @xyz = ????
As your procedure already...
February 23, 2015 at 10:58 pm
If the excel sheet is present on your system and metadata is correct. Try running your package in 32 bit mode.
Right Click Project -> Properties -> Debugging -> Run64bitRuntime to...
February 23, 2015 at 2:00 am
Assing connection string value to a Variable in Child package and try using that variable value as connection string to your connection using expressions.
You can check below post which is...
February 23, 2015 at 1:56 am
Use an ETL tool...or easy way..use SQL Server Import/Export wizard with SQL Server Authentication.
February 23, 2015 at 1:48 am
Use SSIS instead. It is easier and faster.
But, if in case you have to do it in SQL Server only. Then write an SP, validate all records in the staging...
February 23, 2015 at 1:45 am
Create a new Table Type with Columns ProductId and Stock.
Pass this table type as parameter to the SP.
Then join your main table and this parameter table to update your main...
February 22, 2015 at 11:49 pm
You can do it using command line -
AcroRd32.exe /t <file.pdf> <printer_name> <printer_driver> <printer_port>
Eg: 2Printer.exe -s "C:\In\*.PDF" -prn "HP LasetJet 1100"
Or, you can do it using Scrip Task in C#...
February 20, 2015 at 2:02 am
We cannot use any wild cards in file name while sending it using FTP.
Rather while creating this file, store the file name in an SSIS variable and use that variable...
February 20, 2015 at 1:56 am
If you have an extra , (comma) at the end of rows in a 'csv' file. This means you have an extra column.
Just update your file connection manager and remove...
February 20, 2015 at 1:52 am
rocky_498 (2/9/2015)
I am using so far two transformations ( Derived Column, Data Conversion)
Plus I am using SCD..
That would be next question. If I pick Second Option...
February 20, 2015 at 1:49 am
Or try storing 0 (False) or 1 (True) instead.
February 20, 2015 at 1:46 am
you can schedule your package with the SQL job and then check the all information from (msdb..dbo.sysjobhistory) table.
OR
you can use the system variable ("StartTime") and end time with the help...
February 20, 2015 at 1:43 am
Yes, you can use one config file in multiple packages. Just make sure config file name is same in all the packages.
Packages will automatically pick the config values available for...
February 20, 2015 at 1:37 am
Viewing 15 posts - 91 through 105 (of 108 total)