Thanks!Todd S wrote:
Quote:
Originally Posted by
Has anyone ever imported peachtree dat files into SQL Server or know of
a way to do this?
Can anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211Can anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211sqlCan anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211is it possible to generate PDF files from reports programmatically ?
Not quite sure what you mean
but you CAN export a report to PDF format, as well as subscribe to a report with PDF format (auto-sent to your e-mail, or to a network location)
|||Hi,
yep you can do this. As the Reporting Services exposes a webservice interface you can call the Render() method on the Reporting Services.
See this sample: http://msdn2.microsoft.com/en-us/library/aa258532(SQL.80).aspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes it is, although you might have to go to great lengths to accomplish it.And if you do it enough, it might be worth your while to create a class to speed things along. We took this approach when trying to auto-export a report to a PDF file with our system.
The following code was adapted from Chris O'Connor's Channel9 blog (http://channel9.msdn.com/ShowPost.aspx?PostID=87032)
First off, we created a separate Reporting Service Exporter class to use from anywhere inside our enterprise system. This required adding a web reference, which we added to the Objects portion of our project. Import that namespace, and create the class:
Imports Objects.ReportingService
Public Class ReportingServiceExporter
#Region " Properties "
Public Property ReportPath() As String
Get
Return Me.m_sReportPath
End Get
Set(ByVal Value As String)
Me.m_sReportPath = Value
End Set
End Property
Public Property FilePath() As String
Get
Return Me.m_sFilePath
End Get
Set(ByVal Value As String)
Me.m_sFilePath = Value
End Set
End Property
#End Region
#Region " Constructors "
#End Region
#Region " Declarations "
'File types to export to
'HTML 3.2 and 4.0 were removed for simplicity's sake
Public Enum ReportExportFileType
XML
NULL
CSV
IMAGE
PDF
MHTML
EXCEL
HTMLOWC
End Enum
Private Params As New Hashtable
Private m_sReportPath As String = String.Empty
Private m_sFilePath As String = String.Empty
#End Region
#Region " Functions "
Private Function LoadParams() As ReportingService.ParameterValue()
Dim array(Params.Count - 1) As ReportingService.ParameterValue
Dim i As Integer = 0
'Since the Parameter array uses a key-value pair, use a DictionaryEntry to hold the necessary information to construct the parameter array
For Each de As DictionaryEntry In Params
Dim pValue As New ParameterValue
pValue.Name = de.Key.ToString()
pValue.Value = de.Value.ToString()
array(i) = pValue
i += 1
Next
Return array
End Function
Public Function ExportReport(ByVal outputFormat As ReportExportFileType) As Boolean
'Renders the report to the file type specified by outputFormat
'Requires the ReportPath() and FilePath() properties to be set prior to the function call
Dim objReportingService As ReportingService.ReportingService
Dim results As Byte()
Dim fs As System.IO.FileStream
Dim sOutputFormat As String = outputFormat.ToString()
'REQUIRED for method call - but not used
Dim DeviceInfo As String = Nothing
Dim HistoryId As String = Nothing
Dim ShowHideToggle As String = Nothing
Dim RSCredentials As DataSourceCredentials() = Nothing
'OUTPUT variables
Dim RSParamsUsed As ParameterValue()
Dim RSWarnings As Warning()
Dim Encoding As String
Dim MimeType As String
Dim StreamIds As String()
Try
objReportingService = New ReportingService.ReportingService
objReportingService.Url = "http://REPORTSERVER/reportserver/ReportService.asmx" 'This maps to the location of the ReportingServices Web Service; available (by default) in the reportserver folder on your Report Server
objReportingService.Timeout = 600000 'Report will run up to ten minutes before timing out
objReportingService.Credentials = System.Net.CredentialCache.DefaultCredentials
'Renders the report to the results byte array
results = objReportingService.Render(m_sReportPath, sOutputFormat, HistoryId, DeviceInfo, LoadParams(), _
RSCredentials, ShowHideToggle, Encoding, MimeType, RSParamsUsed, RSWarnings, StreamIds)
'Delete any existing file with the same file name
System.IO.File.Delete(m_sFilePath)
'Write to the specified file
fs = System.IO.File.OpenWrite(m_sFilePath)
fs.Write(results, 0, results.Length)
fs.Close()
objReportingService.Dispose()
objReportingService = Nothing
'GC.Collect()
Return True
Catch ex As Exception
DisplayError(ex)
MsgBox("Report Export Failed")
Return False
Finally
objReportingService = Nothing
results = Nothing
fs = Nothing
'GC.Collect()
End Try
End Function
Public Sub AddParameter(ByVal name As String, ByVal value As Object)
Params.Add(name, value)
End Sub
#End Region
End Class
Next, from wherever the event that triggers the export is located, you need to create the Exporter object and set it's parameters, then call the ExportReport function to render the report:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e as System.EventArgs) Handles Button1.Click
Dim exportSucceeded As Boolean
'Prepare the report for exporting
'The ReportingServiceExporter FilePath and ReportPath properties MUST be set before exporting
Dim exporter as New ReportingServiceExporter
'Target output file path - change the extension to whatever format you need to export to
exporter.FilePath = "C:\temp\report.pdf"
'Path to the report on the server, starting from //REPORTSERVER/reportserver, where the web reference inside the ReportingServiceExporter is loaded from; make sure you don't type the .rdl extension
exporter.ReportPath = "/Reporting Services/ReportName"
'Next, simply add the parameters that the report requires
exporter.AddParameter("Param1", value)
exporter.AddParameter("Param2", value)
exporter.AddParameter("Param3", value)
'Finally, call the ExportReport method with the enumerated type of the format
exportSucceeded = exporter.ExportReport(ReportingServiceExporter.ReportExportFileType.PDF)
That's pretty much all there is to it. Hope this helps.
|||thanks for your suggestions.
the idea is replacing an existing solution which creates PDF files from Business Objects automatically.
The datasource contains information for different individuals, and the automatic PDF creation process creates one file per individual.
is it possible to generate PDF files from reports programmatically ?
Not quite sure what you mean
but you CAN export a report to PDF format, as well as subscribe to a report with PDF format (auto-sent to your e-mail, or to a network location)
|||Hi,
yep you can do this. As the Reporting Services exposes a webservice interface you can call the Render() method on the Reporting Services.
See this sample: http://msdn2.microsoft.com/en-us/library/aa258532(SQL.80).aspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes it is, although you might have to go to great lengths to accomplish it.And if you do it enough, it might be worth your while to create a class to speed things along. We took this approach when trying to auto-export a report to a PDF file with our system.
The following code was adapted from Chris O'Connor's Channel9 blog (http://channel9.msdn.com/ShowPost.aspx?PostID=87032)
First off, we created a separate Reporting Service Exporter class to use from anywhere inside our enterprise system. This required adding a web reference, which we added to the Objects portion of our project. Import that namespace, and create the class:
Imports Objects.ReportingService
Public Class ReportingServiceExporter
#Region " Properties "
Public Property ReportPath() As String
Get
Return Me.m_sReportPath
End Get
Set(ByVal Value As String)
Me.m_sReportPath = Value
End Set
End Property
Public Property FilePath() As String
Get
Return Me.m_sFilePath
End Get
Set(ByVal Value As String)
Me.m_sFilePath = Value
End Set
End Property
#End Region
#Region " Constructors "
#End Region
#Region " Declarations "
'File types to export to
'HTML 3.2 and 4.0 were removed for simplicity's sake
Public Enum ReportExportFileType
XML
NULL
CSV
IMAGE
PDF
MHTML
EXCEL
HTMLOWC
End Enum
Private Params As New Hashtable
Private m_sReportPath As String = String.Empty
Private m_sFilePath As String = String.Empty
#End Region
#Region " Functions "
Private Function LoadParams() As ReportingService.ParameterValue()
Dim array(Params.Count - 1) As ReportingService.ParameterValue
Dim i As Integer = 0
'Since the Parameter array uses a key-value pair, use a DictionaryEntry to hold the necessary information to construct the parameter array
For Each de As DictionaryEntry In Params
Dim pValue As New ParameterValue
pValue.Name = de.Key.ToString()
pValue.Value = de.Value.ToString()
array(i) = pValue
i += 1
Next
Return array
End Function
Public Function ExportReport(ByVal outputFormat As ReportExportFileType) As Boolean
'Renders the report to the file type specified by outputFormat
'Requires the ReportPath() and FilePath() properties to be set prior to the function call
Dim objReportingService As ReportingService.ReportingService
Dim results As Byte()
Dim fs As System.IO.FileStream
Dim sOutputFormat As String = outputFormat.ToString()
'REQUIRED for method call - but not used
Dim DeviceInfo As String = Nothing
Dim HistoryId As String = Nothing
Dim ShowHideToggle As String = Nothing
Dim RSCredentials As DataSourceCredentials() = Nothing
'OUTPUT variables
Dim RSParamsUsed As ParameterValue()
Dim RSWarnings As Warning()
Dim Encoding As String
Dim MimeType As String
Dim StreamIds As String()
Try
objReportingService = New ReportingService.ReportingService
objReportingService.Url = "http://REPORTSERVER/reportserver/ReportService.asmx" 'This maps to the location of the ReportingServices Web Service; available (by default) in the reportserver folder on your Report Server
objReportingService.Timeout = 600000 'Report will run up to ten minutes before timing out
objReportingService.Credentials = System.Net.CredentialCache.DefaultCredentials
'Renders the report to the results byte array
results = objReportingService.Render(m_sReportPath, sOutputFormat, HistoryId, DeviceInfo, LoadParams(), _
RSCredentials, ShowHideToggle, Encoding, MimeType, RSParamsUsed, RSWarnings, StreamIds)
'Delete any existing file with the same file name
System.IO.File.Delete(m_sFilePath)
'Write to the specified file
fs = System.IO.File.OpenWrite(m_sFilePath)
fs.Write(results, 0, results.Length)
fs.Close()
objReportingService.Dispose()
objReportingService = Nothing
'GC.Collect()
Return True
Catch ex As Exception
DisplayError(ex)
MsgBox("Report Export Failed")
Return False
Finally
objReportingService = Nothing
results = Nothing
fs = Nothing
'GC.Collect()
End Try
End Function
Public Sub AddParameter(ByVal name As String, ByVal value As Object)
Params.Add(name, value)
End Sub
#End Region
End Class
Next, from wherever the event that triggers the export is located, you need to create the Exporter object and set it's parameters, then call the ExportReport function to render the report:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e as System.EventArgs) Handles Button1.Click
Dim exportSucceeded As Boolean
'Prepare the report for exporting
'The ReportingServiceExporter FilePath and ReportPath properties MUST be set before exporting
Dim exporter as New ReportingServiceExporter
'Target output file path - change the extension to whatever format you need to export to
exporter.FilePath = "C:\temp\report.pdf"
'Path to the report on the server, starting from //REPORTSERVER/reportserver, where the web reference inside the ReportingServiceExporter is loaded from; make sure you don't type the .rdl extension
exporter.ReportPath = "/Reporting Services/ReportName"
'Next, simply add the parameters that the report requires
exporter.AddParameter("Param1", value)
exporter.AddParameter("Param2", value)
exporter.AddParameter("Param3", value)
'Finally, call the ExportReport method with the enumerated type of the format
exportSucceeded = exporter.ExportReport(ReportingServiceExporter.ReportExportFileType.PDF)
That's pretty much all there is to it. Hope this helps.
|||thanks for your suggestions.
the idea is replacing an existing solution which creates PDF files from Business Objects automatically.
The datasource contains information for different individuals, and the automatic PDF creation process creates one file per individual.
Can someone tell me why path to the configuration file couldn't be relative to the package? When I try to use relative path (i.e. do not specify full path to the configuration file) package then run from BIDS looks for configuration file in the solution folder instead of package's folder (project folder).
Is there ane way to force package use same folder to search for caonfiguration files?
Thanks
No unfortunately not. Maybe this is something you could request at http://connect.microsoft.com/sqlserver/feedback
I don't know the rationale for not allowing relative paths but I would guess its because how would you know what the path relative to a package is if the package is stored in SQL Server? If you look at it from this perspective absolute paths make more sense.
-Jamie
|||
Ok. I'll try to live with it now=/
It seems very srange to me why no one at MSFT even think about of deployment process of ETL solutions to end-user's environment
|||So, by the way, may be you know where package will search for configuration files if package stored in "program files\my company\my solution" folder and exeuted by dtexec in the way like this:
dtexec /file:"program files\my company\my solution\mypackage.dtsx"?
|||Andrey Makarov wrote:
Ok. I'll try to live with it now=/
It seems very srange to me why no one at MSFT even think about of deployment process of ETL solutions to end-user's environment
Well, they did think about it. They just got it wrong that's all :) That is to say, there is a bug.
-Jamie
|||So, by the way, may be you know where package will search for configuration files if package stored in "program files\my company\my solution" folder and exeuted by dtexec in the way like this:
dtexec /file:"program files\my company\my solution\mypackage.dtsx"?
No. Perhaps you can tell me?
-Jamie
I used SQL 2000 before. There are options for setting program files path and data path, which I usually install programs on C: and then data files in D: for easier maintenance. However, I cannot find this options in SQL 2005. Is that both (program files and data) must be locate in the same drive/path? or how can I do it same as SQL 2000? Please advise. Many thanks.
During installation time you are able to point certain directories to other paths than the default system path. Although some thing have to be installed on the system path, most of the Sql server parts can be put in different locations on the computer.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Thanks for your reply.
Sure I can find to change the installation path.
However, there are 2 path setting for SQL2000, one for Program Files and another for Data Files. But I only find one in SQL 2005. Does it mean the program files and data files must be in the same location in SQL2005? or else how can I install the Program Files on c: and then Data Files on D: in SQL2005?
Thank you very much for your help.
Maurice
Thanks to some earlier help from this forum, I have my package running using configuration files and Windows Authentication. However, when I try to execute the package using Sql authentication, login fails for the user i am specifying. When I check out the configuration file, the connection string does not contain the password. I added the password to the connection string, but it does not cone back. I followed the instructions found on the following site:
http://www.nigelrivett.net/DTS/SSISConfigurationFile.html
After trying what was suggested there, I was still unsuccessful with my login attempt.
Anyone know how to set up a package to run using Sql authentication?
Thanks!
Craig
At the time of development, set the protection level of package to EncryptSensitiveWithUserKey, after this sertting the package will store the sensitive information like password in itself.
Atul
quote:
> Can anyone help me? I would like to put a password on BAK files everytime
quote:
>
quote:
> Hello All,
> Can anyone help me? I would like to put a password on BAK files everytime
quote:|||Tuoc
> Thanks in Advance,
> Tuoc
quote:
> Hello All,
> Can anyone help me? I would like to put a password on BAK files everytime
quote:|||Kalen,
> Thanks in Advance,
> Tuoc
Hi
Config files doesn't seem to work for me :( i want to make a common config file for all of my packages but it is giving me error
Validation error. The AcquireConnection method call to the connection manager failed with error code 0xC0202009
I have placed pasword in my config file too. Following is config file which i m using, server name n password are masked.
<?xml version="1.0"?>
<DTSConfiguration>
<DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="SSBKD\955688" GeneratedFromPackageName="DTS_ACPM_MarkIT_Indices_Composites_TRAC_X_Asia_Index" GeneratedFromPackageID="{CB3660A1-5E6C-4D08-A7F5-4D6CE83578E2}" GeneratedDate="2006/10/19 14:05:20"/>
</DTSConfigurationHeading>
<Configuration ConfiguredType="Property" Path="\Package.Connections[ssmgn838.ACPM.acpmuser].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>server=########;user id=sa;password=******;database=ACPM;
</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.Connections[Text File (Source)].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>C:\acpm\filetoupload\Copy of ACPM_MarkIT_Indices_Constituents_Composites_1_ITRAXX_ASIA.tab
</ConfiguredValue>
</Configuration>
</DTSConfiguration>
If you take the ConnectionString from the configuration file and use it does the AcquiredConnection works?
The failure happens when you using DTExec or from designer?
Thanks,
Ovidiu
problem came in AcquiredConnection
DTexec throws this error
even in designer it doesnt't identify password, i have to give it manually in my connection object.
|||Can you tell me what type of connection is this? Oledb ADO.net?
Also can you check what is the value for the Package property ProtectionLevel?
Thanks,
Ovidiu
